An interactive web-based dashboard to track COVID-19 in Colombia. Case study: five main cities.

OBJECTIVE: Design and implement an interactive web-based dashboard to track COVID-19 in Colombia. METHODS: A tool was designed and implemented to analyze the data of Covid-19 positive cases in Colombia and published by the Instituto Nacional de Salud. The tool is based on the implementation of business intelligence methods with which you can understand the behavior of the pandemic in Colombia and generate structured data for decision-making by government levels. The tool displays, on a single screen, information on the number of cases, patient status, age ranges, city, location department, and gender. This information can be dynamically filtered and focus analyzes on the national, departmental, or municipal order. Additionally, methods are implemented for trend analysis, both on a linear and semi-log scale, as well as for calculating the case fatality rate in each of the municipalities. RESULTS: A web-based data analysis dashboard is implemented for semi-continuous monitoring of the COVID-19 pandemic in Colombia. With the use of the tool, a situational analysis is carried out for five of the most important cities in Colombia. CONCLUSIONS: The application is effective, flexible, and easy to use. The situational analysis reflects that public policies for the control of the disease have been favorable for Medellín, but for Cartagena, Bogotá, Barranquilla, and Cali, complementary measures are required.

An interactive web-based dashboard to track COVID-19 in Colombia. Case study: five main cities

ABSTRACT Objective Design and implement an interactive web-based dashboard to track COVID-19 in Colombia Methods A tool was designed and implemented to analyze the data of Covid-19 positive cases in Colombia and published by the Instituto Nacional de Salud. The tool is based on the implementation of business intelligence methods with which you can understand the behavior of the pandemic in Colombia and generate structured data for decision-making by government levels. The tool displays, on a single screen, information on the number of cases, patient status, age ranges, city, location department, and gender. This information can be dynamically filtered and focus analyzes on the national, departmental, or municipal order. Additionally, methods are implemented for trend analysis, both on a linear and semi-log scale, as well as for calculating the case fatality rate in each of the municipalities. Results A web-based data analysis dashboard is implemented for semi-continuous monitoring of the COVID-19 pandemic in Colombia. With the use of the tool, a situational analysis is carried out for five of the most important cities in Colombia. Conclusions The application is effective, flexible, and easy to use. The situational analysis reflects that public policies for the control of the disease have been favorable for Medellín, but for Cartagena, Bogotá, Barranquilla, and Cali, complementary measures are required. RESUMEN Objetivo Diseñar e implementar una herramienta dinámica web para el seguimiento de la COVID-19 en Colombia. Métodos Se diseña e implementa una herramienta para el análisis de los datos de los casos positivos de COVID-19 en Colombia y publicados por el Instituto Nacional de Salud. La herramienta se basa en la implementación de métodos de inteligencia empresarial con los que se pueda entender el comportamiento de la pandemia en Colombia y generar datos estructurados para la toma de decisiones por parte de los estamentos gubernamentales. La herramienta despliega, en una sola pantalla, información sobre número de casos, estado de los pacientes, rangos de edad, ciudad y departamento de ubicación y género. Esta información puede ser filtrada de forma dinámica y enfocar los análisis en el orden nacional, departamental o municipal. Adicionalmente, se implementan métodos para el análisis de tendencia, tanto en escala lineal como en escala semilogarítmica, así como para el cálculo de la tasa de letalidad en cada uno de los municipios. Resultados Se implementó una herramienta de análisis de datos basado en la web para el seguimiento semicontinuo de la pandemia de la COVID-19 en Colombia. A partir de la herramienta se realiza un análisis situacional para cinco de las ciudades más importantes de Colombia. Conclusiones El aplicativo es eficaz, flexible y de fácil manejo. El análisis situacional refleja que las políticas públicas para el control de la enfermedad han sido efectivas para Medellín, pero, para Cartagena, Bogotá, Barranquilla y Cali, se requieren medidas complementarias.